Austin Smith
Austin Smith
Reactions
-
Re: I need help with a formula for Schedule Health.
@Natalie11 Is this closer to what you're looking to do? Not sure how you want schedule health broken out if you missed your completion dates. =IF(AND([Completed Date]@row <= [Target End Date]@row,…1 · -
Re: Unparseable formula
@AliT Try: =if([Status]@row="Assigned but not Completed", today()-created@row, "") Dates - dates = integers, don't need the rounding formula.1 · -
Re: Subtract six months from a date
@Kimbh Try this in column B. =IF(MONTH([Column A]@row) > 6, DATE(YEAR([Column A]@row), MONTH([Column A]@row) - 6, 1), IF(MONTH([Column A]@row) < 7, DATE(YEAR([Column A]@row) - 1, MONTH([Column …1 · -
Re: MATCH multi-dropdown to another column text
Try this =IF(CONTAINS([Title], [Audience]), [Business Email Information Email Address], "")1 · -
Re: MATCH multi-dropdown to another column text
Sorry, misunderstood that you wanted it compiled. Yes, Paul is correct about that part. If you put the Contains formula in the Distro list column as a column formula and lock the reference to the Aud…1 ·
